sql subquery with aggregate function

join shbcf.ru